CREATE TABLE [dbo].[Security_Groups]
(
[SECURITY_GROUP] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Security_Groups_SECURITY_GROUP] DEFAULT (''),
[SECURITY_GROUP_DESCR] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Security_Groups_SECURITY_GROUP_DESCR] DEFAULT (''),
[WEBKITENABLED] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_WEBKITENABLED] DEFAULT ((0)),
[ADHOCENABLED] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_ADHOCENABLED] DEFAULT ((0)),
[MEMBERSHIPLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_MEMBERSHIPLEVEL] DEFAULT ((0)),
[MEETINGSLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_MEETINGSLEVEL] DEFAULT ((0)),
[SYSTEMLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_SYSTEMLEVEL] DEFAULT ((0)),
[DUESLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_DUESLEVEL] DEFAULT ((0)),
[CASHARLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_CASHARLEVEL] DEFAULT ((0)),
[ORDERENTRYLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_ORDERENTRYLEVEL] DEFAULT ((0)),
[REFERRALLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_REFERRALLEVEL] DEFAULT ((0)),
[CERTLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_CERTLEVEL] DEFAULT ((0)),
[FRLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_FRLEVEL] DEFAULT ((0)),
[SECURITY_SEQ] [tinyint] NOT NULL CONSTRAINT [DF_Security_Groups_SECURITY_SEQ] DEFAULT ((0)),
[COMMUNITIESLEVEL] [bit] NOT NULL CONSTRAINT [DF_Security_Groups_COMMUNITIESLEVEL] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE TRIGGER [dbo].[asi_Security_Groups_Delete]
ON [dbo].[Security_Groups]
FOR DELETE
AS
BEGIN
    DELETE Security_Filters
    WHERE SECURITY_GROUP = (SELECT d.SECURITY_GROUP FROM deleted d)
END

GO
CREATE TRIGGER [dbo].[asi_Security_Groups_Insert]
ON [dbo].[Security_Groups]
FOR INSERT AS
BEGIN
    INSERT  Security_Filters (SECURITY_GROUP, SECURITY_MODE, TABLE_NAME)
    SELECT    i.SECURITY_GROUP,'BROWSE', st.TABLE_NAME
    FROM    inserted i,  Security_Tables st

    INSERT  Security_Filters (SECURITY_GROUP, SECURITY_MODE, TABLE_NAME)
    SELECT    i.SECURITY_GROUP,'DELETE',  st.TABLE_NAME
    FROM    inserted i,  Security_Tables st

    INSERT  Security_Filters (SECURITY_GROUP, SECURITY_MODE, TABLE_NAME)
    SELECT    i.SECURITY_GROUP,'EDIT',  st.TABLE_NAME
    FROM    inserted i,  Security_Tables st

    INSERT  Security_Filters (SECURITY_GROUP, SECURITY_MODE, TABLE_NAME)
    SELECT    i.SECURITY_GROUP,'SEARCH',  st.TABLE_NAME
    FROM    inserted i,  Security_Tables st

    INSERT  Security_Filters (SECURITY_GROUP, SECURITY_MODE, TABLE_NAME)
    SELECT    i.SECURITY_GROUP,'INSERT',  st.TABLE_NAME
    FROM    inserted i,  Security_Tables st
END

GO
ALTER TABLE [dbo].[Security_Groups] ADD CONSTRAINT [PK_Security_Groups] PRIMARY KEY NONCLUSTERED ([SECURITY_GROUP]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Security_Groups] TO [IMIS]
GRANT SELECT ON  [dbo].[Security_Groups] TO [IMIS]
GRANT INSERT ON  [dbo].[Security_Groups] TO [IMIS]
GRANT DELETE ON  [dbo].[Security_Groups] TO [IMIS]
GRANT UPDATE ON  [dbo].[Security_Groups] TO [IMIS]
GO